<?php 
	require_once "config/constantes.php";
	require_once "config/config.php";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!-- saved from url=(0014)about:internet -->
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>.........::::::::: caRHmo - Desenvolvimento Humano e Empresarial :::::::::.........</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<?php 
	require_once "config/css.ini";
	require_once "config/js.ini";
?>
</head>
<body>
<div id="div_centro" >
  <div id="FWTableContainer474730518" >
    <table width="787" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
      <!-- fwtable fwsrc="" fwpage="Page 1" fwbase="layout_carhmo copy.png" fwstyle="Dreamweaver" fwdocid = "474730518" fwnested="0" -->
      <tr>
        <td width="196"><img src="images/spacer.gif" width="196" height="1" border="0" alt="" /></td>
        <td width="197"><img src="images/spacer.gif" width="197" height="1" border="0" alt="" /></td>
        <td width="2"><img src="images/spacer.gif" width="2" height="1" border="0" alt="" /></td>
        <td width="158"><img src="images/spacer.gif" width="158" height="1" border="0" alt="" /></td>
        <td width="37"><img src="images/spacer.gif" width="37" height="1" border="0" alt="" /></td>
        <td width="2"><img src="images/spacer.gif" width="2" height="1" border="0" alt="" /></td>
        <td width="7"><img src="images/spacer.gif" width="7" height="1" border="0" alt="" /></td>
        <td width="174"><img src="images/spacer.gif" width="174" height="1" border="0" alt="" /></td>
        <td width="14"><img src="images/spacer.gif" width="14" height="1" border="0" alt="" /></td>
        <td width="1"><img src="images/spacer.gif" width="1" height="1" border="0" alt="" /></td>
      </tr>
      <tr>
        <td colspan="10"><img name="a_01" src="images/a_01.png" width="788" height="16" border="0" id="a_01" alt="" /></td>
      </tr>
      <tr>
        <td rowspan="2" colspan="4"><a href="index.php"><img name="b_02" src="images/b_02.png" width="553" height="123" border="0" id="b_02" alt="" /></a></td>
        <td colspan="4">
       			 <?php require_once 'modulos/login/login.php'; ?>
        </td>
        <td rowspan="2" colspan="2"><img name="d_04" src="images/d_04.png" width="15" height="123" border="0" id="d_04" alt="" /></td>
      </tr>
      <tr>
        <td colspan="4" valign="bottom"><img name="e_05" src="images/e_05.png" width="220" height="45" border="0" id="e_05" alt="" /></td>
      </tr>
      <tr>
        <td colspan="10"><img name="f_06" src="images/f_06.png" width="788" height="18" border="0" id="f_06" alt="" /></td>
      </tr>
      <tr>
        <td colspan="10"> 
       
<?php require_once 'menu.php'; ?>
        
        </td>
      </tr>
      <tr>
        <td colspan="10"><img name="o_15" src="images/o_15.png" width="788" height="4" border="0" id="o_15" alt="" /></td>
      </tr>
      <tr>
        <td colspan="5"><img name="p_16" src="images/p_16.png" width="590" height="26" border="0" id="p_16" alt="" /></td>
        <td colspan="2"><img name="q_17" src="images/q_17.png" width="9" height="26" border="0" id="q_17" alt="" /></td>
        
        
        
        <td colspan="3">&nbsp;</td>
      </tr>
      <tr>
        <td colspan="5" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="3">
          <tr>
            <td width="100%" align="left" valign="top"><p>&nbsp;</p></td>
          </tr>
          <tr>
            <td align="left" valign="top"><table width="99" border="0" cellspacing="0" cellpadding="4">
              <tr>
                <td height="37" background="images/tit_buscavagas.jpg">&nbsp;</td>
              </tr>
              <tr>
                <td valign="top"><div style="width:290px; margin-left:15px; text-align:justify">
                  <form id="myForm" name="myForm" method="get" action="vagas.php">
                    <div align="left"><strong>Digite o que procura</strong>
                      <input name="vaga" type="text" class="texta" id="vaga" value="" size="60" />
                      <br />
                      <table width="100%" border="0" cellspacing="0" cellpadding="0">
                        <tr>
                          <td valign="top"><table width="100%" border="0" cellspacing="5" cellpadding="2">
                            <tr>
                              <td width="16%"><strong>Estado:</strong></td>
                              <td width="84%"><select name="sg_uf" class="texta" id="sg_uf" >
                                <option value="all">Indiferente</option>
                                <?php
                                         
                                            $objRecorSet = $objConn->Execute('SELECT DISTINCT
																				  tbl_uf.co_uf,
																				  tbl_uf.sg_uf,
																				  tbl_uf.no_uf
																				FROM
																				  tbl_vaga
																				  INNER JOIN tbl_uf ON (tbl_vaga.sg_uf = tbl_uf.sg_uf) 
																				  order by sg_uf asc' );	
                                            if ( $objRecorSet->_numOfRows > 0 ){	
                                                while( !$objRecorSet->EOF ) {
                                                    echo "<option value='".$objRecorSet->fields['sg_uf']."'>".$objRecorSet->fields['sg_uf']."</option>";
                                                    $objRecorSet->MoveNext();
                                                }
                                         
                                             }
                                         
                                            ?>
                              </select></td>
                            </tr>
                            <tr>
                              <td><strong>Nível:</strong></td>
                              <td><select name="nivel" class="texta" id="nivel" >
                                <option value="all">Indiferente</option>
                                <?php
 
	$objRecorSet = $objConn->Execute('SELECT DISTINCT 
										  tbl_hierarquia.co_hierarquia,
										  tbl_hierarquia.no_hierarquia
										FROM
										  tbl_vaga
										  INNER JOIN tbl_hierarquia ON (tbl_vaga.co_hierarquia = tbl_hierarquia.co_hierarquia) 
										  order by co_hierarquia asc' );	
	if ( $objRecorSet->_numOfRows > 0 ){	
		while( !$objRecorSet->EOF ) {
            echo "<option value='".$objRecorSet->fields['co_hierarquia']."'>".$objRecorSet->fields['no_hierarquia']."</option>";
			$objRecorSet->MoveNext();
		}
 
     }
 
    ?>
                              </select></td>
                            </tr>
                            <tr>
                              <td>&nbsp;</td>
                              <td><input type="image" name="imageField" id="imageField" src="images/buscar.jpg" /></td>
                            </tr>
                          </table></td>
                        </tr>
                      </table>
                      <br />
                    </div>
                  </form>
                </div></td>
              </tr>
            </table>
              <br />
<?php require_once 'modulos/vagas/pesquisa.php'; ?></td>
          </tr>
          <tr>
            <td align="left" valign="top"></td>
          </tr>
        </table></td>
        <td colspan="2" background="images/q_17.png">&nbsp;</td>
        <td colspan="3" valign="top" bgcolor="#DEE3E9"><table width="100%" border="0" cellpadding="4" cellspacing="0" bgcolor="#FFFFFF">
            <tr>
              <td><?php require_once 'modulos/lateral/leftMenu.php'; ?></td>
            </tr>
            <tr>
              <td>&nbsp;</td>
            </tr>
          </table>
          <img src="images/u_21.png" alt="" name="u_21" width="189" height="385" border="0" align="bottom" id="u_21" style="vertical-align:bottom" /></td>
      </tr>
    </table>
</div>
</div>
<div id="div_centro2" style="margin-top:0px" > 
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>© Copyright 2011. Todos os direitos reservados. <a href="http://www.voitech.com.br" target="_blank"><img src="images/desenvolvido.png" alt="VOITECH SISTEMAS" width="150" height="30" border="0" align="absmiddle" longdesc="http://www.voitech.com.br" /></a></p>
</div>
</body>
</html>
